Tabela PatHist

Definicja tabeli PatHist

Name

PatHist

Code

PatHist

Comment

 


Lista kolumn tabeli PatHist

Name

Code

ID

ID

ExtID

ExtID

NationalID

NationalID

FirstName

FirstName

LastName

LastName

DateOB

DateOB

Sex

Sex

Address

Address

OwnerID

OwnerID

UpdUserID

UpdUserID

UpdNr

UpdNr

UpdDate

UpdDate

UpdTime

UpdTime

LockUserID

LockUserID

LockTime

LockTime

FullAcc

FullAcc

ReadAcc

ReadAcc

MaidenName

MaidenName


Kolumna ID tabeli PatHist

Definicja kolumny ID tabeli PatHist

Name

ID

Code

ID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ExtID tabeli PatHist

Definicja kolumny ExtID tabeli PatHist

Name

ExtID

Code

ExtID

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna NationalID tabeli PatHist

Definicja kolumny NationalID tabeli PatHist

Name

NationalID

Code

NationalID

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna FirstName tabeli PatHist

Definicja kolumny FirstName tabeli PatHist

Name

FirstName

Code

FirstName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna LastName tabeli PatHist

Definicja kolumny LastName tabeli PatHist

Name

LastName

Code

LastName

Data Type

VARCHAR2(30)

Mandatory

No

Comment

 


Kolumna DateOB tabeli PatHist

Definicja kolumny DateOB tabeli PatHist

Name

DateOB

Code

DateOB

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Sex tabeli PatHist

Definicja kolumny Sex tabeli PatHist

Name

Sex

Code

Sex

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna Address tabeli PatHist

Definicja kolumny Address tabeli PatHist

Name

Address

Code

Address

Data Type

VARCHAR2(250)

Mandatory

No

Comment

 


Kolumna OwnerID tabeli PatHist

Definicja kolumny OwnerID tabeli PatHist

Name

OwnerID

Code

OwnerID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UpdUserID tabeli PatHist

Definicja kolumny UpdUserID tabeli PatHist

Name

UpdUserID

Code

UpdUserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UpdNr tabeli PatHist

Definicja kolumny UpdNr tabeli PatHist

Name

UpdNr

Code

UpdNr

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna UpdDate tabeli PatHist

Definicja kolumny UpdDate tabeli PatHist

Name

UpdDate

Code

UpdDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna UpdTime tabeli PatHist

Definicja kolumny UpdTime tabeli PatHist

Name

UpdTime

Code

UpdTime

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna LockUserID tabeli PatHist

Definicja kolumny LockUserID tabeli PatHist

Name

LockUserID

Code

LockUserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LockTime tabeli PatHist

Definicja kolumny LockTime tabeli PatHist

Name

LockTime

Code

LockTime

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FullAcc tabeli PatHist

Definicja kolumny FullAcc tabeli PatHist

Name

FullAcc

Code

FullAcc

Data Type

RAW(255)

Mandatory

No

Comment

 


Kolumna ReadAcc tabeli PatHist

Definicja kolumny ReadAcc tabeli PatHist

Name

ReadAcc

Code

ReadAcc

Data Type

RAW(255)

Mandatory

No

Comment

 


Kolumna MaidenName tabeli PatHist

Definicja kolumny MaidenName tabeli PatHist

Name

MaidenName

Code

MaidenName

Data Type

VARCHAR2(32)

Mandatory

No

Comment